package untiring07.swing.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class J26_SungJukDAO {
	private String DRV = "oracle.jdbc.driver.OracleDriver";
	private String URL = "jdbc:oracle:thin:untiring07/untiring07@112.216.253.125:1521:xe";
	private String insertSQL = "insert into sungjuk values (exam.nextval,?,?,?,?,?,?,?,sysdate)";

	protected Connection openDatabase() {
		try {
			Class.forName(DRV);
			return DriverManager.getConnection(URL);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

	protected void closeDatabase(Connection c, PreparedStatement p, ResultSet r) {
		if (r != null) {
			try {
				r.close();
				r = null;
			} catch (Exception e) {
			}
		}
		if (p != null) {
			try {
				p.close();
				p = null;
			} catch (Exception e) {
			}
		}
		if (c != null) {
			try {
				c.close();
				c = null;
			} catch (Exception e) {
			}
		}
	}
	public boolean insertSungJuk(J26_SungJukVO sj){
		Connection conn = null;
		PreparedStatement pstmt = null;
		boolean result = false;
		try{
			conn = this.openDatabase();
			pstmt = conn.prepareStatement(insertSQL);
			pstmt.setString(1, sj.getName());
			pstmt.setString(2, sj.getKor());
			pstmt.setString(3, sj.getEng());
			pstmt.setString(4, sj.getMat());
			pstmt.setString(5, sj.getTot());
			pstmt.setString(6, sj.getAvg());
			pstmt.setString(7, sj.getGrd());
			pstmt.executeUpdate();
			result =true;
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			this.closeDatabase(conn, pstmt, null);
		}
		return result;
	}
}
